﻿using QG.FrontDesk.Core;
using QG.FrontDesk.DAL.IRepository;
using QG.FrontDesk.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace QG.FrontDesk.DAL.Repository
{
   public class ClassifyinfoRepository: IClassifyinfoRepository
    {
        /// <summary>
        /// 获取菜单列表信息
        /// </summary>
        /// <returns></returns>
        public List<Classifyinfo> GetClassifyinfos()
        {
            string sql = @"SELECT * FROM `classifyinfo`";
            return DapperDBHelper<Classifyinfo>.QueryList(sql, null);
        }
        /// <summary>
        /// 获取所有职位名称
        /// </summary>
        /// <returns></returns>
        public List<PostName> GetPostNames()
        {
            string sql = "SELECT * FROM postname";
            return DapperDBHelper<PostName>.QueryList(sql, null);
        }
    }
}
